/*
 Navicat Premium Data Transfer

 Source Server         : cangqiong
 Source Server Type    : MySQL
 Source Server Version : 80403 (8.4.3)
 Source Host           : localhost:3306
 Source Schema         : taxi-service-order

 Target Server Type    : MySQL
 Target Server Version : 80403 (8.4.3)
 File Encoding         : 65001

 Date: 30/05/2025 17:09:59
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for order_info
-- ----------------------------
DROP TABLE IF EXISTS `order_info`;
CREATE TABLE `order_info` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '订单ID',
  `passenger_id` bigint DEFAULT NULL COMMENT '乘客ID',
  `passenger_phone` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '乘客手机号',
  `driver_id` bigint DEFAULT NULL COMMENT '司机ID',
  `driver_phone` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '司机手机号',
  `car_id` bigint DEFAULT NULL COMMENT '车辆Id',
  `vehicle_type` varchar(8) DEFAULT NULL,
  `address` char(6) DEFAULT NULL COMMENT '发起地行政区划代码',
  `order_time` datetime DEFAULT NULL COMMENT '订单发起时间',
  `depart_time` datetime DEFAULT NULL COMMENT '预计用车时间',
  `departure` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '预计出发地点详细地址',
  `dep_longitude` varchar(16) DEFAULT NULL COMMENT '预计出发地点经度',
  `dep_latitude` varchar(16) DEFAULT NULL COMMENT '预计出发地点纬度',
  `destination` varchar(128) DEFAULT NULL COMMENT '预计目的地',
  `dest_longitude` varchar(16) DEFAULT NULL COMMENT '预计目的地经度',
  `dest_latitude` varchar(16) DEFAULT NULL COMMENT '预计目的地纬度',
  `encrypt` int DEFAULT NULL COMMENT '坐标加密标识\r\n1:GCJ-02测绘局标准\r\n2:WGS84 GPS标准\r\n3:BD-09 百度标准\r\n4:CGCS2000 北斗标准\r\n0:其他',
  `fare_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '运价类型编码',
  `fare_version` int DEFAULT NULL,
  `receive_order_car_longitude` varchar(16) DEFAULT NULL COMMENT '接单时车辆经度',
  `receive_order_car_latitude` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '接单时车辆纬度',
  `receive_order_time` datetime DEFAULT NULL COMMENT '接单时间，派单成功时间',
  `license_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '机动车驾驶证号',
  `vehicle_no` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '车辆号牌',
  `to_pick_up_passenger_time` datetime DEFAULT NULL COMMENT '司机去接乘客出发时间',
  `to_pick_up_passenger_longitude` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '去接乘客时，司机的经度',
  `to_pick_up_passenger_latitude` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '去接乘客时，司机的纬度',
  `to_pick_up_passenger_address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '去接乘客时，司机的地点',
  `driver_arrived_departure_time` datetime DEFAULT NULL COMMENT '司机到达上车点时间',
  `pick_up_passenger_time` datetime DEFAULT NULL COMMENT '接到乘客，乘客上车时间',
  `pick_up_passenger_longitude` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '接到乘客，乘客上车经度',
  `pick_up_passenger_latitude` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '接到乘客，乘客上车纬度',
  `passenger_getoff_time` datetime DEFAULT NULL COMMENT '乘客下车时间',
  `passenger_getoff_longitude` varchar(16) DEFAULT NULL COMMENT '乘客下车经度',
  `passenger_getoff_latitude` varchar(16) DEFAULT NULL COMMENT '乘客下车纬度',
  `cancel_time` datetime DEFAULT NULL COMMENT '订单撤销时间',
  `cancel_operator` int DEFAULT NULL COMMENT '撤销发起者：1:乘客\r\n2:驾驶员\r\n3:平台公司',
  `cancel_type_code` int DEFAULT NULL COMMENT '撤销类型代码\r\n1:乘客提前撤销\r\n2:驾驶员提前撤销\r\n3:平台公司撤销\r\n4;乘客违约撤销\r\n5:驾驶员违约撤销',
  `drive_mile` bigint DEFAULT NULL COMMENT '载客里程（米）',
  `drive_time` bigint DEFAULT NULL COMMENT '载客时间(分)',
  `order_status` int DEFAULT NULL COMMENT '订单状态1：订单开始 2：司机接单 3：去接乘客 4：司机到达乘客起点 5：乘客上车，司机开始行程 6：到达目的地，行程结束，未支付 7：发起收款 8: 支付完成 9.订单取消''',
  `price` double(10,2) DEFAULT NULL,
  `gmt_create` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1861244513085919235 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of order_info
-- ----------------------------
BEGIN;
INSERT INTO `order_info` (`id`, `passenger_id`, `passenger_phone`, `driver_id`, `driver_phone`, `car_id`, `vehicle_type`, `address`, `order_time`, `depart_time`, `departure`, `dep_longitude`, `dep_latitude`, `destination`, `dest_longitude`, `dest_latitude`, `encrypt`, `fare_type`, `fare_version`, `receive_order_car_longitude`, `receive_order_car_latitude`, `receive_order_time`, `license_id`, `vehicle_no`, `to_pick_up_passenger_time`, `to_pick_up_passenger_longitude`, `to_pick_up_passenger_latitude`, `to_pick_up_passenger_address`, `driver_arrived_departure_time`, `pick_up_passenger_time`, `pick_up_passenger_longitude`, `pick_up_passenger_latitude`, `passenger_getoff_time`, `passenger_getoff_longitude`, `passenger_getoff_latitude`, `cancel_time`, `cancel_operator`, `cancel_type_code`, `drive_mile`, `drive_time`, `order_status`, `price`, `gmt_create`, `gmt_modified`) VALUES (1111, 1859056057681199106, '12312312312', 1859058039166873601, '18185268503', 1859059556213075970, '1', '110000', '1994-07-01 18:28:13', '1995-12-20 21:06:18', '双馨园', '26.45', '106.68', '博学楼', '26.44', '106.67', NULL, '110000$1', 2, '106.68', '26.44', '2024-11-24 12:14:57', '123123123', '京A12345', NULL, NULL, NULL, NULL, NULL, '2024-11-22 10:03:18', NULL, NULL, NULL, NULL, NULL, '2024-11-25 14:59:39', 2, 5, NULL, NULL, 9, NULL, '2024-11-25 14:59:37', '2024-11-25 14:59:37');
INSERT INTO `order_info` (`id`, `passenger_id`, `passenger_phone`, `driver_id`, `driver_phone`, `car_id`, `vehicle_type`, `address`, `order_time`, `depart_time`, `departure`, `dep_longitude`, `dep_latitude`, `destination`, `dest_longitude`, `dest_latitude`, `encrypt`, `fare_type`, `fare_version`, `receive_order_car_longitude`, `receive_order_car_latitude`, `receive_order_time`, `license_id`, `vehicle_no`, `to_pick_up_passenger_time`, `to_pick_up_passenger_longitude`, `to_pick_up_passenger_latitude`, `to_pick_up_passenger_address`, `driver_arrived_departure_time`, `pick_up_passenger_time`, `pick_up_passenger_longitude`, `pick_up_passenger_latitude`, `passenger_getoff_time`, `passenger_getoff_longitude`, `passenger_getoff_latitude`, `cancel_time`, `cancel_operator`, `cancel_type_code`, `drive_mile`, `drive_time`, `order_status`, `price`, `gmt_create`, `gmt_modified`) VALUES (1859503725343690753, 1859056057681199106, '12312312312', 1859058270457573377, '12312312312', 1859059621971374082, '1', '110000', '1994-07-01 18:28:13', '1995-12-20 21:06:18', '双馨园', '26.45', '106.68', '博学楼', '26.44', '106.67', NULL, '110000$1', 2, '', '', '2024-11-10 16:05:25', '', '', '2024-12-12 12:12:12', '26.45', '106.68', '双馨园', '2024-11-23 22:45:27', '2024-11-22 10:03:18', '26.44', '106.67', '2024-11-24 14:40:39', '26.43857', '106.676957', NULL, NULL, NULL, 560, 9, 7, 10.45, '2024-11-26 10:56:11', '2024-11-26 10:56:11');
INSERT INTO `order_info` (`id`, `passenger_id`, `passenger_phone`, `driver_id`, `driver_phone`, `car_id`, `vehicle_type`, `address`, `order_time`, `depart_time`, `departure`, `dep_longitude`, `dep_latitude`, `destination`, `dest_longitude`, `dest_latitude`, `encrypt`, `fare_type`, `fare_version`, `receive_order_car_longitude`, `receive_order_car_latitude`, `receive_order_time`, `license_id`, `vehicle_no`, `to_pick_up_passenger_time`, `to_pick_up_passenger_longitude`, `to_pick_up_passenger_latitude`, `to_pick_up_passenger_address`, `driver_arrived_departure_time`, `pick_up_passenger_time`, `pick_up_passenger_longitude`, `pick_up_passenger_latitude`, `passenger_getoff_time`, `passenger_getoff_longitude`, `passenger_getoff_latitude`, `cancel_time`, `cancel_operator`, `cancel_type_code`, `drive_mile`, `drive_time`, `order_status`, `price`, `gmt_create`, `gmt_modified`) VALUES (1861035451266142210, 1859056057681199106, '12312312312', NULL, NULL, NULL, '1', '110000', '1994-07-01 18:28:13', '1995-12-20 21:06:18', '双馨园', '40.45', '106.68', '博学楼', '26.44', '106.67', NULL, '110000$1', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2024-11-25 21:13:23', '2024-11-25 21:13:23');
INSERT INTO `order_info` (`id`, `passenger_id`, `passenger_phone`, `driver_id`, `driver_phone`, `car_id`, `vehicle_type`, `address`, `order_time`, `depart_time`, `departure`, `dep_longitude`, `dep_latitude`, `destination`, `dest_longitude`, `dest_latitude`, `encrypt`, `fare_type`, `fare_version`, `receive_order_car_longitude`, `receive_order_car_latitude`, `receive_order_time`, `license_id`, `vehicle_no`, `to_pick_up_passenger_time`, `to_pick_up_passenger_longitude`, `to_pick_up_passenger_latitude`, `to_pick_up_passenger_address`, `driver_arrived_departure_time`, `pick_up_passenger_time`, `pick_up_passenger_longitude`, `pick_up_passenger_latitude`, `passenger_getoff_time`, `passenger_getoff_longitude`, `passenger_getoff_latitude`, `cancel_time`, `cancel_operator`, `cancel_type_code`, `drive_mile`, `drive_time`, `order_status`, `price`, `gmt_create`, `gmt_modified`) VALUES (1861242219455897602, 1859056057681199106, '12312312312', 1859058039166873601, '18185268503', 1859059556213075970, '1', '110000', '1994-07-01 18:28:13', '1995-12-20 21:06:18', '双馨园', '26.45', '106.68', '博学楼', '26.44', '106.67', NULL, '110000$1', 2, '106.68', '26.44', '2024-11-26 10:55:00', '123123123', '京A12345', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, '2024-11-26 10:55:00', '2024-11-26 10:55:00');
INSERT INTO `order_info` (`id`, `passenger_id`, `passenger_phone`, `driver_id`, `driver_phone`, `car_id`, `vehicle_type`, `address`, `order_time`, `depart_time`, `departure`, `dep_longitude`, `dep_latitude`, `destination`, `dest_longitude`, `dest_latitude`, `encrypt`, `fare_type`, `fare_version`, `receive_order_car_longitude`, `receive_order_car_latitude`, `receive_order_time`, `license_id`, `vehicle_no`, `to_pick_up_passenger_time`, `to_pick_up_passenger_longitude`, `to_pick_up_passenger_latitude`, `to_pick_up_passenger_address`, `driver_arrived_departure_time`, `pick_up_passenger_time`, `pick_up_passenger_longitude`, `pick_up_passenger_latitude`, `passenger_getoff_time`, `passenger_getoff_longitude`, `passenger_getoff_latitude`, `cancel_time`, `cancel_operator`, `cancel_type_code`, `drive_mile`, `drive_time`, `order_status`, `price`, `gmt_create`, `gmt_modified`) VALUES (1861244513085919234, 1861039053695127554, '45645645645', 1861040638496178178, '45645645645', 1861073358039384066, '1', '110000', '1994-07-01 18:28:13', '1995-12-20 21:06:18', '双馨园', '26.45', '106.68', '博学楼', '26.44', '106.67', NULL, '110000$1', 2, '106.67523', '26.444853', '2024-11-26 11:04:08', '123123123', '京C12345', '2024-11-26 14:14:00', '26.45', '106.68', '双馨园', '2024-11-26 14:15:34', '2024-11-26 14:16:04', '26.44', '106.67', '2024-11-26 14:59:52', '26.433034', '106.677282', NULL, NULL, NULL, 1173, 43, 8, 12.15, '2024-11-26 15:26:03', '2024-11-26 15:26:03');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
